{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["notes","averages and range"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"notes","index":0,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[null,"AVERAGES"]
[null,"This one is a bit different:"]
[null,"Click on 'New' to generate a new set of numbers"]
[null,"The numbers will be in the range that is specified by the 'Maximum' and 'Minimum'"]
[null,"You can change the 'Maximum' and 'Minimum' by clicking on the up/down arrows"]
[null,"The averages and the range will be calculated automatically"]
[null,"Tapping on the coloured cells will toggle between hiding and showing the values"]
[null,"Be careful - if there is more than one mode, Excel only picks up the first one!"]
[null,"A '##' in the mode cell means 'no mode'."]
[null,"Now click here!"]
[null,"© Copyright 2004 S.A.Lomax, M.J.Nixon.  All Rights Reserved."]

{"sheet":"averages and range","index":1,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,{"$f":"INT(($M$5-$M$4+1)*RAND()+$M$4)","v":9},null,{"$f":"INT(($M$5-$M$4+1)*RAND()+$M$4)","v":11},null,{"$f":"INT(($M$5-$M$4+1)*RAND()+$M$4)","v":7},null,{"$f":"INT(($M$5-$M$4+1)*RAND()+$M$4)","v":9},null,{"$f":"INT(($M$5-$M$4+1)*RAND()+$M$4)","v":7},null,"Minimum  ",5]
[null,null,null,null,null,null,null,null,null,null,null,"Maximum  ",15]
[]
[]
[]
[null,null,"Mean",null,"Median",null,"Mode",null,"Range"]
[]
[null,null,{"$f":"AVERAGE(B4,D4,F4,H4,J4)","v":8.6},null,{"$f":"MEDIAN(B4,D4,F4,H4,J4)","v":9},null,{"$f":"MODE(B4,D4,F4,H4,J4)","v":9},null,{"$f":"MAX(B4,D4,F4,H4,J4)-MIN(B4,D4,F4,H4,J4)","v":4}]
[]
[]
[null,"Tap on the yellow/blue cells to hide/reveal a number"]